System Administration Information
In [ltbSurveyTypes] requires the entry Cyclic - Cyclic Maintenance (SurveyTypeId = 11; SurveyTypeInit = 2; SurveyTypeSort = 11).
Survey Init
In [ltbSurveyInit] requires the entry Gullies - Gully/Catchpit Cleaning (SurveyInitId = 9; SurveyInitType = 2; SurveyInitAssetTypes = GY,CP; SurveyInitDefectActions = 546,547; SurveyInitSort =9).
Defect Item Types
In [tblMasterDefectItems] require additional entries for Gully Clean (GCLN - Gully Clean (GC) - 546), and Gully Dip (GDIP - Gully Inspect/Dip (GC) - 547). Set MDISort = 11, 12; MDIAttribute1 = 53. These items need linking back to the Master Defect 'GC - Highway drain : gully/cpit/int' (7) in [tblMasterDefects].
Defect Attribute Definition
In [tblDefectAttribDefns], add a new Attribute Entry: 53 - Gully Full; 1 - 100 Scale; DefectAttribMin = 0; Defect Attrib Max = 100.
Gully Clean Worksheet Schedule
This is a report definition held in HighStone Home Folder\DocTemplates. The format filename is rptCycMaintenanceGullyList1.xml.
This report needs registering on HighStone before use. The required registration action is included on the Actions menu on the Survey Details form when logged on as HighStone Administrator.
Gully Minimum Inspection Interval
This figure is required for the Gully Maintenance Report. This is set in [tbsSettings] MaintInspIntervalGully. The following styles may be given (the default is 365 days):
1Y {a year is 365 days}
12M {a month is 30 days}
365D
Report Database SQL Definitions [tbsSQLStatements]
The SQL for the Survey Gully List Worksheet is given under SQL definition SYS_SQL_PRINT_GULLYLIST1 (12206).
The SQL for the Gully Status Report is given under SQL definition SYS_SQL_ASSET_GULLY_REPORT (12205).
HighStone takes defaults for both these scripts if none are given.
Gully Status Report
The supporting functions support an 'Entire Network' option but this is not currently offered to Users.
Implementation details are given under HS CRF 10039.